﻿USE [TanNamChinh]
/*
Cập nhật CSDL ngày 18-12-2013
*/

CREATE VIEW [dbo].[viewHT_Databases]
AS
SELECT  name
FROM    sys.sysdatabases
WHERE   HAS_DBACCESS(name) = 1
GO


GO

ALTER VIEW [dbo].[viewHT_AdvanceVoucherFee]
AS
SELECT     dbo.tblFee.ID_Fee, dbo.tblFee.FeeName, dbo.tblFileFee.Price, dbo.tblFileFee.ID_AdvanceVoucher
FROM         dbo.tblFee INNER JOIN
                      dbo.tblFileFee ON dbo.tblFee.ID_Fee = dbo.tblFileFee.ID_Fee

GO


